from biz.mysql.io.BaseSql import sql


class zxxs(sql):

    def get(self) ->str:
        sql='''
        SELECT (SELECT t2.xqmc  FROM T_XQ t2 WHERE t2.xqdm = t.xqm) '校区名称',
        count(1) '在校学生数' 
        FROM T_XSJBXX t 
        WHERE t.sfzx = 1 
        GROUP BY t.xqm
        '''
        return sql